Hierarchy Types

In Pyramid, there are several different types of hierarchy, depending on the datasource and/ or the way in which the hierarchies were constructed in Pyramid. Each hierarchy type is associate with specific features and functions.

Attribute Hierarchies

Attribute hierarchies are "flat" hierarchies existing in the original data source, and containing member elements; each attribute hierarchy corresponds to a single column imported from the data source. The member elements contained within the attribute hierarchy correspond to the objects within the column imported from the datasource.

Attribute hierarchies do not enable drill paths; to leverage drill functions, you must add a regular hierarchy or a drill path hierarchy.

Regular Hierarchies

Regular hierarchies contain multiple attribute hierarchies, organized into levels, thereby enabling drill functionality. They also display expand and collapse buttons in grid visualizations, and display the drill path in the Elements panel.

Drill Path Hierarchies

While drill path hierarchies are structurally the same as regular hierarchies, unlike regular hierarchies, they do not display expand and collapse icons in grid visualizations. Instead, the expand and collapse functions are accessed via the context menu, and the expanded levels are displays in a new column.

Drill path hierarchies also reflect the current hierarchy level in the drop zones and Elements panel, rather than displaying the drill path.

Geospatial Hierarchies

Geospatial Hierarchies are hierarchies containing geographical locations (like latitude, longitude, countries, states, cities, or zip codes) that have been assigned to a geospatial type. Geospatial hierarchies can be used to create map visualizations, in order to display your data set across a geographic location.

Date-Time Hierarchies

Date-Time Hierarchies are hierarchies containing date-time member elements and have been assigned as a date-time type. They can be added to the query, or used to create classic date-time groupings (like year, month, week, etc), or to construct complex date-time calculations that can be saved and added to the query. They can also be used to create calendar slicers, where you can filter the query by date-time groupings or formulations that don't exist in the date model.

Parent-Child Hierarchies

In MS OLAP, Tabular, and SAP models, the hierarchical structures configured in the cube are reflected in Pyramid. Parent-Child Hierarchies in MS OLAP and BW datasources are reflected in Pyramid; these hierarchies can be easily navigated, and can be used to create custom lists and formulas.

Image Hierarchies

Hierarchies consisting of image URLs can be added to the query, and the corresponding images displayed when the given visualization type is a grid or Cartesian chart. Click here to learn more.